[UNUNDERSTANDING ERROR] Excel lost the horizontal scrollbar? How to fix?

Excel lost the horizontal scrollbar, so your experience with this software is a bit difficult? Immediately refer to TipsMake's troubleshooting methods to fix this confusing problem in 1 minute!

The scroll bar, also known as the scroll bar in Excel, plays a very important role. This scroll bar appears when a window has content that is too large to display entirely on one window. Then, the horizontal scroll bar or vertical scroll bar will help you move left, right or up and down the page. It seems like the scroll bar is always in its place. But during work, some users encountered a confusing error that Excel lost the horizontal scroll bar . TipsMake has researched this problem and has a specific solution.

Cause and how to fix Excel error of losing horizontal scroll bar

There are many reasons why the horizontal scroll bar in Excel is lost. There is a high possibility that the user has not enabled horizontal scroll bars for Excel. Or the horizontal scroll bar is minimized or out of view. To fix this problem, here are the tips you should apply.

Detailed instructions on how to display horizontal scroll bars in Excel

As I shared, you have not enabled scroll bar display in Excel so you cannot see the horizontal or vertical scroll bar. To enable these scroll bars, you need to do the following:

1. Step 1 : At the open Excel file > User clicks on File tab > Select Options .
2. Step 2 : Select the Advance option in the left menu > Scroll down to Display options for this workbook . Tick ​​the lines Show horizontal scroll bar (Show horizontal scroll bar) and Show vertical scroll bar (Show vertical scroll bar) > Click OK .

This method applies to Excel 2010, 2013, 2016.

For Excel 2007 version

1. Step 1 : Click the Microsoft Button > Click Excel Options .
2. Step 2 : Click on Advanced > Go to Display > Tick select S how horizontal scroll bar and Show vertical scroll bar > OK .

For Excel 2003 version

1. Step 1 : In the open Excel file > Click the Tools tab > Select Options .
2. Step 2 : Click on the View tab > Tick and select 2 items: Horizontal scroll bar and Vertical scroll bar .

 

2/ Disable minimized scroll bars

In case the display of horizontal/vertical scroll bars has been enabled but the horizontal scroll bar is still missing. There is a high possibility that the scroll bar is being minimized and the solution is as follows:

1. Step 1 : In the Excel file that is losing the horizontal scroll bar, look at the bottom right corner of the screen and you will see 3 vertical dots.
2. Step 2 : Drag the mouse to the position of those 3 dots, you will see the mouse change to an arrow shape> Click and Drag to the left to enlarge the horizontal scroll bar.

3/ Resize the Excel window

It is possible that the size of the Excel window has been reduced or changed, causing the horizontal scroll bar to be hidden. To find this scrollbar again, resizing is the trick you should do. First, you need to find the file name in the middle of the Excel file > Click and hold on the name and drag it to the left until you see the edges of this Excel file displayed > Then, drag it to the right again so that the The left edge of the Excel file is visible (as shown) > Click the zoom button to see if the horizontal scroll bar is displayed again.

Besides, users should also change the size of the application window by: Right-clicking on the title bar of the Excel application window > Select Maximize > Right-clicking on the title bar again and selecting restore > Check Check to see if the horizontal scroll bar appears.

How to fix the Excel error of losing the horizontal scroll bar is not difficult, right? TipsMake hopes that these solutions will help you fix errors quickly. You can leave a comment to let the admin know which solution helped you fix the problem! Wishing you success and working with Excel more easily.